package com.ssish.saas.eccs.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EspTxtexpsummExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EspTxtexpsummExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPayorcdIsNull() {
            addCriterion("PAYORCD is null");
            return (Criteria) this;
        }

        public Criteria andPayorcdIsNotNull() {
            addCriterion("PAYORCD is not null");
            return (Criteria) this;
        }

        public Criteria andPayorcdEqualTo(String value) {
            addCriterion("PAYORCD =", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotEqualTo(String value) {
            addCriterion("PAYORCD <>", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdGreaterThan(String value) {
            addCriterion("PAYORCD >", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORCD >=", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLessThan(String value) {
            addCriterion("PAYORCD <", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLessThanOrEqualTo(String value) {
            addCriterion("PAYORCD <=", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLike(String value) {
            addCriterion("PAYORCD like", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotLike(String value) {
            addCriterion("PAYORCD not like", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdIn(List<String> values) {
            addCriterion("PAYORCD in", values, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotIn(List<String> values) {
            addCriterion("PAYORCD not in", values, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdBetween(String value1, String value2) {
            addCriterion("PAYORCD between", value1, value2, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotBetween(String value1, String value2) {
            addCriterion("PAYORCD not between", value1, value2, "payorcd");
            return (Criteria) this;
        }

        public Criteria andReftypIsNull() {
            addCriterion("REFTYP is null");
            return (Criteria) this;
        }

        public Criteria andReftypIsNotNull() {
            addCriterion("REFTYP is not null");
            return (Criteria) this;
        }

        public Criteria andReftypEqualTo(String value) {
            addCriterion("REFTYP =", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypNotEqualTo(String value) {
            addCriterion("REFTYP <>", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypGreaterThan(String value) {
            addCriterion("REFTYP >", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypGreaterThanOrEqualTo(String value) {
            addCriterion("REFTYP >=", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypLessThan(String value) {
            addCriterion("REFTYP <", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypLessThanOrEqualTo(String value) {
            addCriterion("REFTYP <=", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypLike(String value) {
            addCriterion("REFTYP like", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypNotLike(String value) {
            addCriterion("REFTYP not like", value, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypIn(List<String> values) {
            addCriterion("REFTYP in", values, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypNotIn(List<String> values) {
            addCriterion("REFTYP not in", values, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypBetween(String value1, String value2) {
            addCriterion("REFTYP between", value1, value2, "reftyp");
            return (Criteria) this;
        }

        public Criteria andReftypNotBetween(String value1, String value2) {
            addCriterion("REFTYP not between", value1, value2, "reftyp");
            return (Criteria) this;
        }

        public Criteria andRefnoIsNull() {
            addCriterion("REFNO is null");
            return (Criteria) this;
        }

        public Criteria andRefnoIsNotNull() {
            addCriterion("REFNO is not null");
            return (Criteria) this;
        }

        public Criteria andRefnoEqualTo(String value) {
            addCriterion("REFNO =", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoNotEqualTo(String value) {
            addCriterion("REFNO <>", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoGreaterThan(String value) {
            addCriterion("REFNO >", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoGreaterThanOrEqualTo(String value) {
            addCriterion("REFNO >=", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoLessThan(String value) {
            addCriterion("REFNO <", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoLessThanOrEqualTo(String value) {
            addCriterion("REFNO <=", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoLike(String value) {
            addCriterion("REFNO like", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoNotLike(String value) {
            addCriterion("REFNO not like", value, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoIn(List<String> values) {
            addCriterion("REFNO in", values, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoNotIn(List<String> values) {
            addCriterion("REFNO not in", values, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoBetween(String value1, String value2) {
            addCriterion("REFNO between", value1, value2, "refno");
            return (Criteria) this;
        }

        public Criteria andRefnoNotBetween(String value1, String value2) {
            addCriterion("REFNO not between", value1, value2, "refno");
            return (Criteria) this;
        }

        public Criteria andInsbyIsNull() {
            addCriterion("INSBY is null");
            return (Criteria) this;
        }

        public Criteria andInsbyIsNotNull() {
            addCriterion("INSBY is not null");
            return (Criteria) this;
        }

        public Criteria andInsbyEqualTo(String value) {
            addCriterion("INSBY =", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotEqualTo(String value) {
            addCriterion("INSBY <>", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyGreaterThan(String value) {
            addCriterion("INSBY >", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyGreaterThanOrEqualTo(String value) {
            addCriterion("INSBY >=", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLessThan(String value) {
            addCriterion("INSBY <", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLessThanOrEqualTo(String value) {
            addCriterion("INSBY <=", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLike(String value) {
            addCriterion("INSBY like", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotLike(String value) {
            addCriterion("INSBY not like", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyIn(List<String> values) {
            addCriterion("INSBY in", values, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotIn(List<String> values) {
            addCriterion("INSBY not in", values, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyBetween(String value1, String value2) {
            addCriterion("INSBY between", value1, value2, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotBetween(String value1, String value2) {
            addCriterion("INSBY not between", value1, value2, "insby");
            return (Criteria) this;
        }

        public Criteria andInsdtIsNull() {
            addCriterion("INSDT is null");
            return (Criteria) this;
        }

        public Criteria andInsdtIsNotNull() {
            addCriterion("INSDT is not null");
            return (Criteria) this;
        }

        public Criteria andInsdtEqualTo(Date value) {
            addCriterion("INSDT =", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotEqualTo(Date value) {
            addCriterion("INSDT <>", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtGreaterThan(Date value) {
            addCriterion("INSDT >", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtGreaterThanOrEqualTo(Date value) {
            addCriterion("INSDT >=", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtLessThan(Date value) {
            addCriterion("INSDT <", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtLessThanOrEqualTo(Date value) {
            addCriterion("INSDT <=", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtIn(List<Date> values) {
            addCriterion("INSDT in", values, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotIn(List<Date> values) {
            addCriterion("INSDT not in", values, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtBetween(Date value1, Date value2) {
            addCriterion("INSDT between", value1, value2, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotBetween(Date value1, Date value2) {
            addCriterion("INSDT not between", value1, value2, "insdt");
            return (Criteria) this;
        }

        public Criteria andUpdbyIsNull() {
            addCriterion("UPDBY is null");
            return (Criteria) this;
        }

        public Criteria andUpdbyIsNotNull() {
            addCriterion("UPDBY is not null");
            return (Criteria) this;
        }

        public Criteria andUpdbyEqualTo(String value) {
            addCriterion("UPDBY =", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotEqualTo(String value) {
            addCriterion("UPDBY <>", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyGreaterThan(String value) {
            addCriterion("UPDBY >", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyGreaterThanOrEqualTo(String value) {
            addCriterion("UPDBY >=", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLessThan(String value) {
            addCriterion("UPDBY <", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLessThanOrEqualTo(String value) {
            addCriterion("UPDBY <=", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLike(String value) {
            addCriterion("UPDBY like", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotLike(String value) {
            addCriterion("UPDBY not like", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyIn(List<String> values) {
            addCriterion("UPDBY in", values, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotIn(List<String> values) {
            addCriterion("UPDBY not in", values, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyBetween(String value1, String value2) {
            addCriterion("UPDBY between", value1, value2, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotBetween(String value1, String value2) {
            addCriterion("UPDBY not between", value1, value2, "updby");
            return (Criteria) this;
        }

        public Criteria andUpddtIsNull() {
            addCriterion("UPDDT is null");
            return (Criteria) this;
        }

        public Criteria andUpddtIsNotNull() {
            addCriterion("UPDDT is not null");
            return (Criteria) this;
        }

        public Criteria andUpddtEqualTo(Date value) {
            addCriterion("UPDDT =", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotEqualTo(Date value) {
            addCriterion("UPDDT <>", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtGreaterThan(Date value) {
            addCriterion("UPDDT >", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDDT >=", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtLessThan(Date value) {
            addCriterion("UPDDT <", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtLessThanOrEqualTo(Date value) {
            addCriterion("UPDDT <=", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtIn(List<Date> values) {
            addCriterion("UPDDT in", values, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotIn(List<Date> values) {
            addCriterion("UPDDT not in", values, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtBetween(Date value1, Date value2) {
            addCriterion("UPDDT between", value1, value2, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotBetween(Date value1, Date value2) {
            addCriterion("UPDDT not between", value1, value2, "upddt");
            return (Criteria) this;
        }

        public Criteria andExpstsIsNull() {
            addCriterion("EXPSTS is null");
            return (Criteria) this;
        }

        public Criteria andExpstsIsNotNull() {
            addCriterion("EXPSTS is not null");
            return (Criteria) this;
        }

        public Criteria andExpstsEqualTo(String value) {
            addCriterion("EXPSTS =", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsNotEqualTo(String value) {
            addCriterion("EXPSTS <>", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsGreaterThan(String value) {
            addCriterion("EXPSTS >", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsGreaterThanOrEqualTo(String value) {
            addCriterion("EXPSTS >=", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsLessThan(String value) {
            addCriterion("EXPSTS <", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsLessThanOrEqualTo(String value) {
            addCriterion("EXPSTS <=", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsLike(String value) {
            addCriterion("EXPSTS like", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsNotLike(String value) {
            addCriterion("EXPSTS not like", value, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsIn(List<String> values) {
            addCriterion("EXPSTS in", values, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsNotIn(List<String> values) {
            addCriterion("EXPSTS not in", values, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsBetween(String value1, String value2) {
            addCriterion("EXPSTS between", value1, value2, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpstsNotBetween(String value1, String value2) {
            addCriterion("EXPSTS not between", value1, value2, "expsts");
            return (Criteria) this;
        }

        public Criteria andExpdtIsNull() {
            addCriterion("EXPDT is null");
            return (Criteria) this;
        }

        public Criteria andExpdtIsNotNull() {
            addCriterion("EXPDT is not null");
            return (Criteria) this;
        }

        public Criteria andExpdtEqualTo(Date value) {
            addCriterion("EXPDT =", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtNotEqualTo(Date value) {
            addCriterion("EXPDT <>", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtGreaterThan(Date value) {
            addCriterion("EXPDT >", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtGreaterThanOrEqualTo(Date value) {
            addCriterion("EXPDT >=", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtLessThan(Date value) {
            addCriterion("EXPDT <", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtLessThanOrEqualTo(Date value) {
            addCriterion("EXPDT <=", value, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtIn(List<Date> values) {
            addCriterion("EXPDT in", values, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtNotIn(List<Date> values) {
            addCriterion("EXPDT not in", values, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtBetween(Date value1, Date value2) {
            addCriterion("EXPDT between", value1, value2, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpdtNotBetween(Date value1, Date value2) {
            addCriterion("EXPDT not between", value1, value2, "expdt");
            return (Criteria) this;
        }

        public Criteria andExpcntIsNull() {
            addCriterion("EXPCNT is null");
            return (Criteria) this;
        }

        public Criteria andExpcntIsNotNull() {
            addCriterion("EXPCNT is not null");
            return (Criteria) this;
        }

        public Criteria andExpcntEqualTo(Integer value) {
            addCriterion("EXPCNT =", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntNotEqualTo(Integer value) {
            addCriterion("EXPCNT <>", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntGreaterThan(Integer value) {
            addCriterion("EXPCNT >", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXPCNT >=", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntLessThan(Integer value) {
            addCriterion("EXPCNT <", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntLessThanOrEqualTo(Integer value) {
            addCriterion("EXPCNT <=", value, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntIn(List<Integer> values) {
            addCriterion("EXPCNT in", values, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntNotIn(List<Integer> values) {
            addCriterion("EXPCNT not in", values, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntBetween(Integer value1, Integer value2) {
            addCriterion("EXPCNT between", value1, value2, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpcntNotBetween(Integer value1, Integer value2) {
            addCriterion("EXPCNT not between", value1, value2, "expcnt");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoIsNull() {
            addCriterion("EXPBATCHNO is null");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoIsNotNull() {
            addCriterion("EXPBATCHNO is not null");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoEqualTo(Integer value) {
            addCriterion("EXPBATCHNO =", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoNotEqualTo(Integer value) {
            addCriterion("EXPBATCHNO <>", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoGreaterThan(Integer value) {
            addCriterion("EXPBATCHNO >", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXPBATCHNO >=", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoLessThan(Integer value) {
            addCriterion("EXPBATCHNO <", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoLessThanOrEqualTo(Integer value) {
            addCriterion("EXPBATCHNO <=", value, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoIn(List<Integer> values) {
            addCriterion("EXPBATCHNO in", values, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoNotIn(List<Integer> values) {
            addCriterion("EXPBATCHNO not in", values, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoBetween(Integer value1, Integer value2) {
            addCriterion("EXPBATCHNO between", value1, value2, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andExpbatchnoNotBetween(Integer value1, Integer value2) {
            addCriterion("EXPBATCHNO not between", value1, value2, "expbatchno");
            return (Criteria) this;
        }

        public Criteria andDwldtIsNull() {
            addCriterion("DWLDT is null");
            return (Criteria) this;
        }

        public Criteria andDwldtIsNotNull() {
            addCriterion("DWLDT is not null");
            return (Criteria) this;
        }

        public Criteria andDwldtEqualTo(Date value) {
            addCriterion("DWLDT =", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotEqualTo(Date value) {
            addCriterion("DWLDT <>", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtGreaterThan(Date value) {
            addCriterion("DWLDT >", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtGreaterThanOrEqualTo(Date value) {
            addCriterion("DWLDT >=", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtLessThan(Date value) {
            addCriterion("DWLDT <", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtLessThanOrEqualTo(Date value) {
            addCriterion("DWLDT <=", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtIn(List<Date> values) {
            addCriterion("DWLDT in", values, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotIn(List<Date> values) {
            addCriterion("DWLDT not in", values, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtBetween(Date value1, Date value2) {
            addCriterion("DWLDT between", value1, value2, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotBetween(Date value1, Date value2) {
            addCriterion("DWLDT not between", value1, value2, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwlcntIsNull() {
            addCriterion("DWLCNT is null");
            return (Criteria) this;
        }

        public Criteria andDwlcntIsNotNull() {
            addCriterion("DWLCNT is not null");
            return (Criteria) this;
        }

        public Criteria andDwlcntEqualTo(Integer value) {
            addCriterion("DWLCNT =", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntNotEqualTo(Integer value) {
            addCriterion("DWLCNT <>", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntGreaterThan(Integer value) {
            addCriterion("DWLCNT >", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntGreaterThanOrEqualTo(Integer value) {
            addCriterion("DWLCNT >=", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntLessThan(Integer value) {
            addCriterion("DWLCNT <", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntLessThanOrEqualTo(Integer value) {
            addCriterion("DWLCNT <=", value, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntIn(List<Integer> values) {
            addCriterion("DWLCNT in", values, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntNotIn(List<Integer> values) {
            addCriterion("DWLCNT not in", values, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntBetween(Integer value1, Integer value2) {
            addCriterion("DWLCNT between", value1, value2, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andDwlcntNotBetween(Integer value1, Integer value2) {
            addCriterion("DWLCNT not between", value1, value2, "dwlcnt");
            return (Criteria) this;
        }

        public Criteria andResdtIsNull() {
            addCriterion("RESDT is null");
            return (Criteria) this;
        }

        public Criteria andResdtIsNotNull() {
            addCriterion("RESDT is not null");
            return (Criteria) this;
        }

        public Criteria andResdtEqualTo(Date value) {
            addCriterion("RESDT =", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtNotEqualTo(Date value) {
            addCriterion("RESDT <>", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtGreaterThan(Date value) {
            addCriterion("RESDT >", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtGreaterThanOrEqualTo(Date value) {
            addCriterion("RESDT >=", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtLessThan(Date value) {
            addCriterion("RESDT <", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtLessThanOrEqualTo(Date value) {
            addCriterion("RESDT <=", value, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtIn(List<Date> values) {
            addCriterion("RESDT in", values, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtNotIn(List<Date> values) {
            addCriterion("RESDT not in", values, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtBetween(Date value1, Date value2) {
            addCriterion("RESDT between", value1, value2, "resdt");
            return (Criteria) this;
        }

        public Criteria andResdtNotBetween(Date value1, Date value2) {
            addCriterion("RESDT not between", value1, value2, "resdt");
            return (Criteria) this;
        }

        public Criteria andRescntIsNull() {
            addCriterion("RESCNT is null");
            return (Criteria) this;
        }

        public Criteria andRescntIsNotNull() {
            addCriterion("RESCNT is not null");
            return (Criteria) this;
        }

        public Criteria andRescntEqualTo(Integer value) {
            addCriterion("RESCNT =", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntNotEqualTo(Integer value) {
            addCriterion("RESCNT <>", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntGreaterThan(Integer value) {
            addCriterion("RESCNT >", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntGreaterThanOrEqualTo(Integer value) {
            addCriterion("RESCNT >=", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntLessThan(Integer value) {
            addCriterion("RESCNT <", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntLessThanOrEqualTo(Integer value) {
            addCriterion("RESCNT <=", value, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntIn(List<Integer> values) {
            addCriterion("RESCNT in", values, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntNotIn(List<Integer> values) {
            addCriterion("RESCNT not in", values, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntBetween(Integer value1, Integer value2) {
            addCriterion("RESCNT between", value1, value2, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRescntNotBetween(Integer value1, Integer value2) {
            addCriterion("RESCNT not between", value1, value2, "rescnt");
            return (Criteria) this;
        }

        public Criteria andRemIsNull() {
            addCriterion("REM is null");
            return (Criteria) this;
        }

        public Criteria andRemIsNotNull() {
            addCriterion("REM is not null");
            return (Criteria) this;
        }

        public Criteria andRemEqualTo(String value) {
            addCriterion("REM =", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotEqualTo(String value) {
            addCriterion("REM <>", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemGreaterThan(String value) {
            addCriterion("REM >", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemGreaterThanOrEqualTo(String value) {
            addCriterion("REM >=", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLessThan(String value) {
            addCriterion("REM <", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLessThanOrEqualTo(String value) {
            addCriterion("REM <=", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLike(String value) {
            addCriterion("REM like", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotLike(String value) {
            addCriterion("REM not like", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemIn(List<String> values) {
            addCriterion("REM in", values, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotIn(List<String> values) {
            addCriterion("REM not in", values, "rem");
            return (Criteria) this;
        }

        public Criteria andRemBetween(String value1, String value2) {
            addCriterion("REM between", value1, value2, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotBetween(String value1, String value2) {
            addCriterion("REM not between", value1, value2, "rem");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}